﻿CREATE TABLE [dbo].[BookOfWorkSystemVariance] (
    [PeriodYear]       INT             NOT NULL,
    [WeekNumber]       INT             NOT NULL,
    [ReferenceDate]    DATE            NOT NULL,
    [ProgramId]        VARCHAR (30)    NOT NULL,
    [ProgramName]      VARCHAR (255)   NOT NULL,
    [ProgramManager]   VARCHAR (255)   NULL,
    [ProjectId]        VARCHAR (10)    NOT NULL,
    [ProjectName]      VARCHAR (200)   NULL,
    [AccountLevel1]    VARCHAR (25)    NOT NULL,
    [BowFlag]          VARCHAR (10)    NOT NULL,
    [SystemGocCode]    VARCHAR (20)    NOT NULL,
    [ManagedGeography] VARCHAR (10)    NULL,
    [Value0]           DECIMAL (38, 3) NULL,
    [Value1]           DECIMAL (38, 3) NULL,
    [Value2]           DECIMAL (38, 3) NULL,
    [Value3]           DECIMAL (38, 3) NULL,
    [Value4]           DECIMAL (38, 3) NULL,
    [Value5]           DECIMAL (38, 3) NULL,
    [Month]            SMALLINT        NULL
);

